[H2 and Firebird]auto_increment, identity or trigger plus generator?

Posted by blow on Stack Overflow See other posts from Stack Overflow or by blow
Published on 2010-05-03T17:02:27Z Indexed on 2010/05/03 17:08 UTC
Read the original article Hit count: 220

Filed under:

h2

|

firebird

|

database

|

auto-increment

Hi all, in Firebird the only way to have an auto increment coloumn is to setup a generator and use it with a trigger.

In H2 db there are auto_increment and identity keywords to do it.

What is the best way?

Mysql use auto_increment too, but there is some problems with cuncurrence read and table lock, isn't true?

Thank you.

© Stack Overflow or respective owner

Related posts about h2

[H2 database] Frontends tool to manage H2 database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, what's the best frontend tool to manage H2 database? Create table, alter table, add coloumn ecc ecc.. Thanks. >>> More
Is my hard drive about to die?

as seen on Server Fault - Search for 'Server Fault'
I have two hard drives set up as a RAID 1 array on my server (Linux, software RAID using mdadm) and one of them just got me this "present" in syslog: Nov 23 02:05:29 h2 kernel: [7305215.338153] ata1.00: exception Emask 0x0 SAct 0x1 SErr 0x0 action 0x0 Nov 23 02:05:29 h2 kernel: [7305215.338178] ata1… >>> More
Play Framework: Error getting sequence nextval using H2 in-memory database

as seen on Stack Overflow - Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory. I set up a basic unit test: public class ModelTest { @Test public void checkThatIndustriesExist() { running(fakeApplication(inMemoryDatabase()), new Runnable() { public… >>> More
h2 (embedded mode ) database files problem

as seen on Stack Overflow - Search for 'Stack Overflow'
There is a h2-database file in my src directory (Java, Eclipse): h2test.db The problem: starting the h2.jar from the command line (and thus the h2 browser interface on port 8082), I have created 2 tables, 'test1' and 'test2' in h2test.db and I have put some data in them; when trying to access them… >>> More
showing the breadcrumb trail in the menu

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a global menu and local menu for the products. I would like to highlight 'our products' link when I am showing the products and also highlight the name of the product and its subpages in the local menu so the highlighted links will work as the breadcrumbs. How can I do this with jquery and… >>> More

Related posts about firebird

How to migrate data from a Firebird database to PostGreSQL on Linux

as seen on Server Fault - Search for 'Server Fault'
Are there any good tools to migrate existing firebird databases to PostgreSQL for Linux systems? I've looked at: FBexport which can be used to dump the data as insert statements, but it's mainly written to export/import from one firebird db to another, not as a migration tool. There's also: Firebird… >>> More
Firebird .NET: Database backup not working (small file)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am trying to backup my Firebird 2.5 database file by code: FbBackup backupSvc = new FbBackup(); backupSvc.ConnectionString = MyConnectionManager.buildConnectionString(); backupSvc.BackupFiles.Add(new FbBackupFile(backupPathFilenameAndExtension, 2048)); backupSvc.Verbose = true; backupSvc.Options… >>> More
Need to compare blobs in firebird

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, I need to check on the contents of blobs in my databases (yes, plural, but one problem at a time). In one database, I have about 900 images of potentially varying sizes. I need to check to see if the versioning system that's built into our application is actually correctly replicating… >>> More
Does firebird support transactional schema changes?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does firebird support transactional schema changes? It seems to me that MySQL does not (am I correct?). >>> More
Firebird sequence-backed ID shorthand

as seen on Stack Overflow - Search for 'Stack Overflow'
What do others do to simplify the creation of simple, serial surrogate keys populated by a SEQUENCE (a.k.a. GENERATOR) in Firebird = 2.1? I finc the process comparatively arduous: For example, in PostgreSQL, I simply type: pg> CREATE TABLE tbl ( > id SERIAL NOT NULL PRIMARY KEY, >… >>> More